Telegram Group & Telegram Channel
Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 101 | 2022-05-15 | 500 |
| 2 | 102 | 2022-06-20 | 750 |
| 3 | 103 | 2022-06-25 | 1000 |
| 4 | 101 | 2022-07-10 | 300 |
| 5 | 104 | 2022-08-05 | 900 |

Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A) SELECT CustomerID, MAX(TotalAmount) FROM Orders

B) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)

C) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)

D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID



tg-me.com/sql_for_qa/108
Create:
Last Update:

Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 101 | 2022-05-15 | 500 |
| 2 | 102 | 2022-06-20 | 750 |
| 3 | 103 | 2022-06-25 | 1000 |
| 4 | 101 | 2022-07-10 | 300 |
| 5 | 104 | 2022-08-05 | 900 |

Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A) SELECT CustomerID, MAX(TotalAmount) FROM Orders

B) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)

C) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)

D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID

BY SQL для тестировщика


Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/108

View MORE
Open in Telegram


SQL для тестировщика Telegram | DID YOU KNOW?

Date: |

Should You Buy Bitcoin?

In general, many financial experts support their clients’ desire to buy cryptocurrency, but they don’t recommend it unless clients express interest. “The biggest concern for us is if someone wants to invest in crypto and the investment they choose doesn’t do well, and then all of a sudden they can’t send their kids to college,” says Ian Harvey, a certified financial planner (CFP) in New York City. “Then it wasn’t worth the risk.” The speculative nature of cryptocurrency leads some planners to recommend it for clients’ “side” investments. “Some call it a Vegas account,” says Scott Hammel, a CFP in Dallas. “Let’s keep this away from our real long-term perspective, make sure it doesn’t become too large a portion of your portfolio.” In a very real sense, Bitcoin is like a single stock, and advisors wouldn’t recommend putting a sizable part of your portfolio into any one company. At most, planners suggest putting no more than 1% to 10% into Bitcoin if you’re passionate about it. “If it was one stock, you would never allocate any significant portion of your portfolio to it,” Hammel says.

Newly uncovered hack campaign in Telegram

The campaign, which security firm Check Point has named Rampant Kitten, comprises two main components, one for Windows and the other for Android. Rampant Kitten’s objective is to steal Telegram messages, passwords, and two-factor authentication codes sent by SMS and then also take screenshots and record sounds within earshot of an infected phone, the researchers said in a post published on Friday.

SQL для тестировщика from ar


Telegram SQL для тестировщика
FROM USA